<?php
namespace app\admin\controller;
use app\admin\model\Address;
use think\Controller;
use Util\Sysdb;
use think\Db;
class Test extends Controller
{
    public function index(){
        $tenantss = Db::table('ty_room')->select();
        dump($tenantss);
        $this->db = new Sysdb();
        $tenants = $this->db->table('room')->lists();
        dump($tenants);

        $tenantss = Db::table('ty_admin_admins')->select();
        dump($tenantss);
        $this->db = new Sysdb();
        $tenants = $this->db->table('admin_admins')->lists();
        dump($tenants);die;
//        include 'PHPExcel.php';
//
//        include 'PHPExcel/Writer/Excel2007.php';
//
////或者include 'PHPExcel/Writer/Excel5.php';用于输出.xls的创建一个excel
//$objPHPExcel = new PHPExcel();
////保存excel—2007格式
//$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
////或者$objWriter = new PHPExcel_Writer_Excel5($objPHPExcel);非2007格式
//$objWriter->save("xxx.xlsx");
////直接输出到浏览器
//$objWriter = new PHPExcel_Writer_Excel5($objPHPExcel);
//header("Pragma: public");header("Expires: 0");
//header("Cache-Control:must-revalidate, post-check=0, pre-check=0");
//header("Content-Type:application/force-download");
//header("Content-Type:application/vnd.ms-execl");
//header("Content-Type:application/octet-stream");
//header("Content-Type:application/download");;
//header('Content-Disposition:attachment;filename="resume.xls"');
//header("Content-Transfer-Encoding:binary");
//$objWriter->save('php://output');
//
////设置excel的属性：创建人
//$objPHPExcel->getProperties()->setCreator("Maarten Balliauw");
//$objPHPExcel->getProperties()->setLastModifiedBy("Maarten Balliauw");
////标题
//$objPHPExcel->getProperties()->setTitle("Office 2007 XLSX Test Document");
//
////题目
//
//$objPHPExcel->getProperties()->setSubject("Office 2007 XLSX Test Document");
//
////描述
//
//$objPHPExcel->getProperties()->setDescription("Test document for Office 2007 XLSX,generated using PHP classes.");
//
////关键字
//
//$objPHPExcel->getProperties()->setKeywords("office 2007 openxml php");
//
////种类
//
//$objPHPExcel->getProperties()->setCategory("Test result file");
//
//
////设置当前的sheet
//
//$objPHPExcel->setActiveSheetIndex(0);
//
////设置sheet的name
//
//$objPHPExcel->getActiveSheet()->setTitle('Simple');
//
////设置单元格的值
//
//$objPHPExcel->getActiveSheet()->setCellValue('A1', 'String');
//
//$objPHPExcel->getActiveSheet()->setCellValue('A2', 12);
//
//$objPHPExcel->getActiveSheet()->setCellValue('A3', true);
//
//$objPHPExcel->getActiveSheet()->setCellValue('C5', '=SUM(C2:C4)');
//
//$objPHPExcel->getActiveSheet()->setCellValue('B8', '=MIN(B2:C5)');
//
////合并单元格
//
//$objPHPExcel->getActiveSheet()->mergeCells('A18:E22');
//
////分离单元格
//
//$objPHPExcel->getActiveSheet()->unmergeCells('A28:B28');
//
//
//
////保护cell
//
//$objPHPExcel->getActiveSheet()->getProtection()->setSheet(true);
//
//// Needs to be set to true in order to enable any worksheet protection!
//
//$objPHPExcel->getActiveSheet()->protectCells('A3:E13', 'PHPExcel');
//
////设置格式
//
//// Set cell number formatsecho date('H:i:s') . " Set cell number formats\n";
//
//$objPHPExcel->getActiveSheet()->getStyle('E4')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_CURRENCY_EUR_SIMPLE);
//
//$objPHPExcel->getActiveSheet()->duplicateStyle( $objPHPExcel->getActiveSheet()->getStyle('E4'), 'E5:E13' );
//
////设置宽width// Set column widths
//$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setAutoSize(true);
//
//$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(12);
//
////设置font
//$objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setName('Candara');
//
//$objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setSize(20);
//
//$objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setBold(true);
//
//$objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setUnderline(PHPExcel_Style_Font::UNDERLINE_SINGLE);
//
//$objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_WHITE);
//
//$objPHPExcel->getActiveSheet()->getStyle('E1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_WHITE);
//
//$objPHPExcel->getActiveSheet()->getStyle('D13')->getFont()->setBold(true);
//
//$objPHPExcel->getActiveSheet()->getStyle('E13')->getFont()->setBold(true);
//
////设置
//
////align
//        $objPHPExcel->getActiveSheet()->getStyle('D11')->getAlignment()->
//
//        setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
//
//$objPHPExcel->getActiveSheet()->getStyle('D12')->getAlignment()->
//
//setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
//
//$objPHPExcel->getActiveSheet()->getStyle('D13')->getAlignment()->
//
//setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
//
//$objPHPExcel->getActiveSheet()->getStyle('A18')->getAlignment()->
//
//setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_JUSTIFY);
//
////垂直居中
//
//$objPHPExcel->getActiveSheet()->getStyle('A18')->getAlignment()->
//
//setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
//
////设置column的border
//$objPHPExcel->getActiveSheet()->getStyle('A4')->getBorders()->getTop()->
//
//        setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);$objPHPExcel->getActiveSheet()->getStyle('B4')->
//
//        getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
//
//$objPHPExcel->getActiveSheet()->getStyle('C4')->getBorders()->getTop()->
//
//setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
//
//$objPHPExcel->getActiveSheet()->getStyle('D4')->getBorders()->getTop()->
//
//setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
//
//$objPHPExcel->getActiveSheet()->getStyle('E4')->getBorders()->getTop()->
//
//setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
//
////设置border的color
//        $objPHPExcel->getActiveSheet()->getStyle('D13')->getBorders()->getLeft()->
//
//        getColor()->setARGB('FF993300');
//
//$objPHPExcel->getActiveSheet()->getStyle('D13')->getBorders()->getTop()->getColor()->setARGB('FF993300');
//
//$objPHPExcel->getActiveSheet()->getStyle('D13')->getBorders()->getBottom()->getColor()->setARGB('FF993300');
//
//$objPHPExcel->getActiveSheet()->getStyle('E13')->getBorders()->getTop()->getColor()->setARGB('FF993300');
//
//$objPHPExcel->getActiveSheet()->getStyle('E13')->getBorders()->getBottom()->getColor()->setARGB('FF993300');
//
//$objPHPExcel->getActiveSheet()->getStyle('E13')->getBorders()->getRight()->getColor()->setARGB('FF993300');
//
////设置填充颜色
//
//$objPHPExcel->getActiveSheet()->getStyle('A1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
//
//$objPHPExcel->getActiveSheet()->getStyle('A1')->getFill()->getStartColor()->setARGB('FF808080');
//
//$objPHPExcel->getActiveSheet()->getStyle('B1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
//
//$objPHPExcel->getActiveSheet()->getStyle('B1')->getFill()->getStartColor()->setARGB('FF808080');
//
////加图片
//$objDrawing = new PHPExcel_Worksheet_Drawing();$objDrawing->setName('Logo');
//
//$objDrawing->setDescription('Logo');$objDrawing->setPath('./images/officelogo.jpg');
//
//$objDrawing->setHeight(36);$objDrawing->setWorksheet($objPHPExcel->getActiveSheet());
//
//$objDrawing = new PHPExcel_Worksheet_Drawing();$objDrawing->setName('Paid');
//
//$objDrawing->setDescription('Paid');$objDrawing->setPath('./images/paid.png');
//
//$objDrawing->setCoordinates('B15');$objDrawing->setOffsetX(110);
//
//$objDrawing->setRotation(25);$objDrawing->getShadow()->setVisible(true);
//
//$objDrawing->getShadow()->setDirection(45);$objDrawing->setWorksheet($objPHPExcel->getActiveSheet());
//
////处理中文输出问题需要将字符串转化为UTF-8编码，才能正常输出，否则中文字符将输出为空白，
//
////如下处理：
////$str  = iconv('gb2312', 'utf-8', $str);
//
////或者你可以写一个函数专门处理中文字符串：
//function convertUTF8($str){
//    if(empty($str)) return '';   return  iconv('gb2312', 'utf-8', $str);
//}
////从数据库输出数据处理方式从数据库读取数据如：
//
//$db = new Mysql($dbconfig);
//
//$sql = "SELECT * FROM  表名";
//
//$row = $db->GetAll($sql);
//
//// $row 为二维数组
//
//$count = count($row);
//
//for ($i = 2; $i <= $count+1; $i++) {
//
//    $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, convertUTF8($row[$i-2][1]));
//
//    $objPHPExcel->getActiveSheet()->setCellValue('B' . $i, convertUTF8($row[$i-2][2]));
//
//    $objPHPExcel->getActiveSheet()->setCellValue('C' . $i, convertUTF8($row[$i-2][3]));
//
//    $objPHPExcel->getActiveSheet()->setCellValue('D' . $i, convertUTF8($row[$i-2][4]));
//
//    $objPHPExcel->getActiveSheet()->setCellValue('E' . $i, convertUTF8(date("Y-m-d", $row[$i-2][5])));
//
//    $objPHPExcel->getActiveSheet()->setCellValue('F' . $i, convertUTF8($row[$i-2][6]));
//
//    $objPHPExcel->getActiveSheet()->setCellValue('G' . $i, convertUTF8($row[$i-2][7]));
//
//    $objPHPExcel->getActiveSheet()->setCellValue('H' . $i, convertUTF8($row[$i-2][8]));
//
//}
//
//
//
////在默认sheet后，创建一个worksheetecho date('H:i:s') . " Create new Worksheet object\n";
//
//$objPHPExcel->createSheet();
//
//$objWriter = PHPExcel_IOFactory::createWriter($objExcel, 'Excel5');
//
//$objWriter-save('php://output');




        set_time_limit(0);
        ini_set('memory_limit', '1024M');
        $myfile = fopen("1.txt", "r") or die("Unable to open file!");
//        $i = 0;
        while(! feof($myfile))
        {
//            $i++;
            $str =fgets($myfile);
//            dump(strlen($str));
//            dump(strlen($str)>1);
            strlen($str)>1&&file_put_contents("2.txt",$str,FILE_APPEND);
//            dump(fgets($myfile));
//            dump($i.'----'.$str. "<br/>");
//            Db::connect('mysql://root:1234@127.0.0.1:3306/test#utf8')
//                ->table('img')
//                ->where(['id'=>intval($i/27)+1])
//                ->find();
            //echo $str = $i.'----'.iconv("GBK", "UTF-8", fgets($myfile)). "<br />";
        }
        fclose($myfile);
//        $file_path = "1.txt";
//        if(file_exists($file_path)){
//            $fp = fopen($file_path,"r");
//            $str = "";
//            $buffer = 1024;//每次读取 1024 字节
//            while(!feof($fp)){//循环读取，直至读取完整个文件
//                $str .= fread($fp,$buffer);
//            }
//            $str = str_replace("\r\n","<br />",$str);
//            echo $str;
//            fclose($fp);
//        }


        die;
        $this->db = new Sysdb;
        $res = $this->db->table('admin_admins')->field('id,username')->lists();
//        $res = $this->db->table('admin_admins')->lists();
//        foreach ($res as $k=>$v){
//            $v['password']=md5($v['phone'].'123456');
//            $up = $this->db->where(['id'=>$v['id']])->update($v);
//            dump($up);
//        }
        dump($res);
    }

    public function test(){
        $this->db = new Sysdb;
        $address = $this->db->table('address')->lists();
        foreach ($address as $k => $v) {
            $arr[$v['a4']]=$v;
            $arr['a1'][]=$v['a1'];
            $arr['a2'][]=$v['a2'];
            $arr['a3'][]=$v['a3'];
        }
        $array = array_flip($arr['a3']);
        $i=1;
        foreach ($array as $k => $v) {
            $array[$k] = $i;
            $i++;
        }
        dump($array);
        set_time_limit(0);
//            $this->db->table('address')
        foreach ($address as $k => $v) {
            $address[$k]['p3'] = $array[$v['a3']];
            $this->db->table('address')->where(array('id'=>$v['id']))->update(['p3'=>$array[$v['a3']]]);
        }
        dump($address);
    }
    public function test2(){
        $this->db = new Sysdb;
        $pid = input('get.pid');
        $menus = $this->db->table('admin_menus')->where(array('pid'=>$pid))->lists();

        // 返回上级菜单
        $backid = 0;
        if($pid > 0){
            $parent = $this->db->table('admin_menus')->where(array('mid'=>$pid))->item();
            $backid = $parent['pid'];
        }

        $this->assign('pid',$pid);
        $this->assign('backid',$backid);
        $this->assign('data',$menus);
        return $this->fetch();
    }
    public function test3(){

    $fileName = "url.xls";

    if (!file_exists($fileName)) {

        exit("文件".$fileName."不存在");

    }

    $startTime = time(); //返回当前时间的Unix 时间戳

    require_once './PHPExcel/IOFactory.php';

    $objPHPExcel = PHPExcel_IOFactory::load($fileName);

    //获取sheet表格数目

    $sheetCount = $objPHPExcel->getSheetCount();

    //默认选中sheet0表

    $sheetSelected = 0;$objPHPExcel->setActiveSheetIndex($sheetSelected);

    //获取表格行数

    $rowCount = $objPHPExcel->getActiveSheet()->getHighestRow();

    //获取表格列数

    $columnCount = $objPHPExcel->getActiveSheet()->getHighestColumn();

    echo "<div>Sheet Count : ".$sheetCount."　　行数： ".$rowCount."　　列数：".$columnCount."</div>";

    $dataArr = array();



    /* 循环读取每个单元格的数据 */

    //行数循环

    for ($row = 1; $row <= $rowCount; $row++){

    //列数循环 , 列数是以A列开始

        for ($column = 'A'; $column <= $columnCount; $column++) {

            $dataArr[] = $objPHPExcel->getActiveSheet()->getCell($column.$row)->getValue();

            echo $column.$row.":".$objPHPExcel->getActiveSheet()->getCell($column.$row)->getValue()."<br />";

        }

        echo "<br/>消耗的内存为：".(memory_get_peak_usage(true) / 1024 / 1024)."M";

        $endTime = time();

        echo "<div>解析完后，当前的时间为：".date("Y-m-d H:i:s")."总共消耗的时间为：".(($endTime - $startTime))."秒</div>";

    var_dump($dataArr);

    $dataArr = NULL;}
    }
}